package com.weilaiwd.admin.constant;

public interface Sql {
	
	public interface Admin {
		String checkLogin = "select * from admin where username = ? and password = ?";
	}
	
	public interface Channel {
		String findAll = "select * from channel";
		String findNoParent = "select a.id from channel a where (select count(*) from channel b where b.id = a.pid) = 0 and a.id <> 0";
	}
	
	public interface Article {
		String getArticlesByChannelId = "from article where channel_id = ?";
	}

}
